package work.mediway.mdm.core.constant;

import java.util.Map;

import cn.hutool.core.map.MapUtil;

/**
 * @author zhongyj <1126834403@qq.com><br/>
 * @date 2020/1/21
 */
public class SQLConstant {

    public static Map<String, String> relaceStr = MapUtil.newHashMap();

    static {
        relaceStr.put("longblob", "varchar(4096)");
        relaceStr.put("sysdate()", "GETDATE()");
    }

    /**
     * 系统名称
     */
    public static final String SCHEMA_NAME = "mdm_User";
    public static final String SCHEMA_NAME_DOT = "mdm.User";

    /**
     * SQL连接词
     */
    public static final String SQL_CONJ_AND = " AND ";

    /**
     * SQL连接词
     */
    public static final String SQL_CONJ_WHERE = " WHERE ";
    public static final String SQL_SELECT = "SELECT ";
    public static final String SQL_FROM = " FROM ";
    public static final String SQL_CREATE_TABLE = "CREATE TABLE ";
    public static final String SQL_INSERT_INTO = "INSERT INTO ";
    public static final String SQL_VALUES = "VALUES";

    public static final String MYSQL_ENGINE = " engine=innodb ";
    public static final String MYSQL_COMMENT = " comment";

    public static final String SELECT_COUNT = "SELECT COUNT(1) FROM {}";

}
